<!DOCTYPE html>
<html lang="zh-CN">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>工作表配置 | Luckysheet文档</title>
    <meta name="generator" content="VuePress 1.8.0">
    
    <meta name="description" content="Luckysheet ，一款纯前端类似excel的在线表格，功能强大、配置简单、完全开源。本站包含官方配置文档,API,教程。">
    <meta property="article:modified_time" content="2021-01-19T01:33:53.000Z">
    <meta property="og:title" content="工作表配置">
    <meta property="og:type" content="website">
    <meta property="og:url" content="https://mengshukeji.github.io/LuckysheetDemo/zh/guide/sheet.html">
    <meta name="twitter:title" content="工作表配置">
    <meta name="twitter:url" content="https://mengshukeji.github.io/LuckysheetDemo/zh/guide/sheet.html">
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:label1" content="Written by">
    
    <link rel="preload" href="/LuckysheetDocs/assets/css/0.styles.58462003.css" as="style"><link rel="preload" href="/LuckysheetDocs/assets/js/app.02d9598d.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/2.daa13025.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/33.eded6080.js" as="script"><link rel="prefetch" href="/LuckysheetDocs/assets/js/10.866635ea.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/11.825eabba.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/12.980dcb91.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/13.119fa3a0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/14.61ea2478.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/15.51a43d85.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/16.de626d16.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/17.e9ae302c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/18.46d5e5a0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/19.6ab6bd88.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/20.a4dd0048.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/21.cf5034d8.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/22.c45a4387.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/23.e08fd533.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/24.d1e4369b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/25.291afc50.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/26.e74f90a6.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/27.1142ecb7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/28.d6d28da0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/29.1ae5f953.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/3.c428902d.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/30.bf70d4f4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/31.d87cf3af.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/32.a1b6f5f4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/4.b5e0f872.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/5.e526f9d4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/6.8106d72b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/7.c0fe87fd.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/8.abc5c19b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/9.2bf3882a.js">
    <link rel="stylesheet" href="/LuckysheetDocs/assets/css/0.styles.58462003.css">
  </head>
  <body>
    <div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/LuckysheetDocs/zh/" class="home-link router-link-active"><img src="/LuckysheetDocs/img/logo.png" alt="Luckysheet文档" class="logo"> <span class="site-name can-hide">Luckysheet文档</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/LuckysheetDocs/zh/" class="nav-link">
  首页
</a></div><div class="nav-item"><a href="/LuckysheetDocs/zh/guide/" class="nav-link router-link-active">
  指南
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  演示
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="了解更多" class="dropdown-title"><span class="title">了解更多</span> <span class="arrow down"></span></button> <button type="button" aria-label="了解更多" class="mobile-dropdown-title"><span class="title">了解更多</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/about/" class="nav-link">
  关于
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="选择语言" class="dropdown-title"><span class="title">选择语言</span> <span class="arrow down"></span></button> <button type="button" aria-label="选择语言" class="mobile-dropdown-title"><span class="title">选择语言</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/sheet.html" class="nav-link">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/sheet.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><a href="/LuckysheetDocs/zh/" class="nav-link">
  首页
</a></div><div class="nav-item"><a href="/LuckysheetDocs/zh/guide/" class="nav-link router-link-active">
  指南
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  演示
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="了解更多" class="dropdown-title"><span class="title">了解更多</span> <span class="arrow down"></span></button> <button type="button" aria-label="了解更多" class="mobile-dropdown-title"><span class="title">了解更多</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/about/" class="nav-link">
  关于
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="选择语言" class="dropdown-title"><span class="title">选择语言</span> <span class="arrow down"></span></button> <button type="button" aria-label="选择语言" class="mobile-dropdown-title"><span class="title">选择语言</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/sheet.html" class="nav-link">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/sheet.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav>  <ul class="sidebar-links"><li><a href="/LuckysheetDocs/zh/guide/" aria-current="page" class="sidebar-link">快速上手</a></li><li><a href="/LuckysheetDocs/zh/guide/config.html" class="sidebar-link">整体配置</a></li><li><a href="/LuckysheetDocs/zh/guide/sheet.html" aria-current="page" class="active sidebar-link">工作表配置</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/sheet.html#初始化配置" class="sidebar-link">初始化配置</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/sheet.html#调试信息" class="sidebar-link">调试信息</a></li></ul></li><li><a href="/LuckysheetDocs/zh/guide/cell.html" class="sidebar-link">单元格</a></li><li><a href="/LuckysheetDocs/zh/guide/operate.html" class="sidebar-link">表格操作</a></li><li><a href="/LuckysheetDocs/zh/guide/api.html" class="sidebar-link">API</a></li><li><a href="/LuckysheetDocs/zh/guide/resource.html" class="sidebar-link">教程与资源</a></li><li><a href="/LuckysheetDocs/zh/guide/FAQ.html" class="sidebar-link">常见问题</a></li><li><a href="/LuckysheetDocs/zh/guide/contribute.html" class="sidebar-link">贡献指南</a></li></ul> </aside> <main class="page"> <div class="theme-default-content content__default"><h1 id="工作表配置"><a href="#工作表配置" class="header-anchor">#</a> 工作表配置</h1> <h2 id="初始化配置"><a href="#初始化配置" class="header-anchor">#</a> 初始化配置</h2> <p>表格初始化配置<code>options</code>时，需要配置一个由每个工作表参数组成的一维数组，赋给<code>options.data</code>。</p> <blockquote><p>表格初始化完成之后，通过方法<a href="/LuckysheetDocs/zh/guide/api.html#getAllSheets([setting])"><code>luckysheet.getAllSheets()</code></a>可以获取所有工作表的配置信息。</p></blockquote> <p>options.data示例如下：</p> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Cell&quot;</span><span class="token punctuation">,</span> <span class="token comment">//工作表名称</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//工作表颜色</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//工作表索引</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//激活状态</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//工作表的下标</span>
        <span class="token property">&quot;hide&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span><span class="token comment">//是否隐藏</span>
        <span class="token property">&quot;row&quot;</span><span class="token operator">:</span> <span class="token number">36</span><span class="token punctuation">,</span> <span class="token comment">//行数</span>
        <span class="token property">&quot;column&quot;</span><span class="token operator">:</span> <span class="token number">18</span><span class="token punctuation">,</span> <span class="token comment">//列数</span>
        <span class="token property">&quot;defaultRowHeight&quot;</span><span class="token operator">:</span> <span class="token number">19</span><span class="token punctuation">,</span> <span class="token comment">//自定义行高</span>
        <span class="token property">&quot;defaultColWidth&quot;</span><span class="token operator">:</span> <span class="token number">73</span><span class="token punctuation">,</span> <span class="token comment">//自定义列宽</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//初始化使用的单元格数据</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;merge&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//合并单元格</span>
            <span class="token property">&quot;rowlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//表格行高</span>
            <span class="token property">&quot;columnlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//表格列宽</span>
            <span class="token property">&quot;rowhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//隐藏行</span>
            <span class="token property">&quot;colhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//隐藏列</span>
            <span class="token property">&quot;borderInfo&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//边框</span>
            <span class="token property">&quot;authority&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//工作表保护</span>
            
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;scrollLeft&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//左右滚动条位置</span>
        <span class="token property">&quot;scrollTop&quot;</span><span class="token operator">:</span> <span class="token number">315</span><span class="token punctuation">,</span> <span class="token comment">//上下滚动条位置</span>
        <span class="token property">&quot;luckysheet_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//选中的区域</span>
        <span class="token property">&quot;calcChain&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span><span class="token comment">//公式链</span>
        <span class="token property">&quot;isPivotTable&quot;</span><span class="token operator">:</span><span class="token boolean">false</span><span class="token punctuation">,</span><span class="token comment">//是否数据透视表</span>
        <span class="token property">&quot;pivotTable&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//数据透视表设置</span>
        <span class="token property">&quot;filter_select&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//筛选范围</span>
        <span class="token property">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span><span class="token comment">//筛选配置</span>
        <span class="token property">&quot;luckysheet_alternateformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//交替颜色</span>
        <span class="token property">&quot;luckysheet_alternateformat_save_modelCustom&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//自定义交替颜色	</span>
        <span class="token property">&quot;luckysheet_conditionformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//条件格式</span>
        <span class="token property">&quot;frozen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//冻结行列配置</span>
        <span class="token property">&quot;chart&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//图表配置</span>
        <span class="token property">&quot;zoomRatio&quot;</span><span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">// 缩放比例</span>
        <span class="token property">&quot;image&quot;</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//图片</span>
        <span class="token property">&quot;showGridLines&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//是否显示网格线</span>
        <span class="token property">&quot;dataVerification&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span> <span class="token comment">//数据验证配置</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet2&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet3&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div><h3 id="name"><a href="#name" class="header-anchor">#</a> name</h3> <ul><li>类型：String</li> <li>默认值：&quot;Sheet1&quot;</li> <li>作用：工作表名称</li></ul> <hr> <h3 id="color"><a href="#color" class="header-anchor">#</a> color</h3> <ul><li>类型：String</li> <li>默认值：&quot;##f20e0e&quot;</li> <li>作用：工作表颜色,工作表名称下方会有一条底部边框</li></ul> <hr> <h3 id="index"><a href="#index" class="header-anchor">#</a> index</h3> <ul><li>类型：String</li> <li>默认值：&quot;&quot;</li> <li>作用：工作表索引，作为唯一key值使用，新增工作表时会自动赋值一个随机字符串。注意<code>index</code>不是工作表顺序，和<code>order</code>区分开。</li></ul> <hr> <h3 id="status"><a href="#status" class="header-anchor">#</a> status</h3> <ul><li>类型：Number</li> <li>默认值：1</li> <li>作用： 激活状态，仅有一个激活状态的工作表，其他工作表为 0</li></ul> <hr> <h3 id="order"><a href="#order" class="header-anchor">#</a> order</h3> <ul><li>类型：Number</li> <li>默认值：0</li> <li>作用： 工作表的下标，代表工作表在底部sheet栏展示的顺序，新增工作表时会递增，从0开始</li></ul> <hr> <h3 id="hide"><a href="#hide" class="header-anchor">#</a> hide</h3> <ul><li>类型：Number</li> <li>默认值：0</li> <li>作用： 是否隐藏，<code>0</code>为不隐藏，<code>1</code>为隐藏</li></ul> <hr> <h3 id="row"><a href="#row" class="header-anchor">#</a> row</h3> <ul><li>类型：Number</li> <li>默认值：36</li> <li>作用： 单元格行数</li></ul> <hr> <h3 id="column"><a href="#column" class="header-anchor">#</a> column</h3> <ul><li>类型：Number</li> <li>默认值：18</li> <li>作用： 单元格列数</li></ul> <hr> <h3 id="defaultrowheight"><a href="#defaultrowheight" class="header-anchor">#</a> defaultRowHeight</h3> <ul><li>类型：Number</li> <li>默认值：19</li> <li>作用： 自定义的默认行高，单位为px</li></ul> <hr> <h3 id="defaultcolwidth"><a href="#defaultcolwidth" class="header-anchor">#</a> defaultColWidth</h3> <ul><li>类型：Number</li> <li>默认值：73</li> <li>作用： 自定义的默认列宽，单位为px</li></ul> <hr> <h3 id="celldata"><a href="#celldata" class="header-anchor">#</a> celldata</h3> <ul><li><p>类型：Array</p></li> <li><p>默认值：[]</p></li> <li><p>作用： 原始单元格数据集，存储sheet中所有单元格中的值，是一个包含<code>{r:0,c:0,v:{m:&quot;value&quot;,v:&quot;value&quot;,ct: {fa: &quot;General&quot;, t: &quot;g&quot;}}}</code>格式单元格信息的一维数组，只在初始化的时候使用。</p> <p>r代表行，c代表列，v代表该单元格的值，值可以是字符、数字或者对象。</p> <p>Luckysheet在建立的时候会根据 <code>options.data[i].row</code> 和 <code>options.data[i].column</code> 的行列数量大小新建一个表格data，然后再使用 <code>data[r][c]=v</code> 的方式填充表格数据，空数据单元格以null表示。</p> <p>使用celldata初始化完表格后，数据转换为luckysheetfile中的字段<a href="#data">data</a>，如<code>luckysheetfile[i].data</code>,后续操作表格的数据更新，会更新到这个data字段中，celldata不再使用。</p></li> <li><p>示例：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
    <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
    <span class="token string">&quot;v&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
    <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
    <span class="token string">&quot;v&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <blockquote><p>详细了解 <a href="/LuckysheetDocs/zh/guide/cell.html">单元格格式</a></p></blockquote> <hr> <h3 id="config"><a href="#config" class="header-anchor">#</a> config</h3> <ul><li><p>类型：Object</p></li> <li><p>默认值：{}</p></li> <li><p>作用：表格行高、列宽、合并单元格、边框、隐藏行等设置</p> <p>注意，config如果为空,必须为空对象<code>{}</code>,不能为字符串或者null</p></li></ul> <h4 id="config-merge"><a href="#config-merge" class="header-anchor">#</a> config.merge</h4> <ul><li>类型：Object</li> <li>默认值：{}</li> <li>作用：合并单元格设置</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
        <span class="token string">&quot;13_5&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">13</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">1</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;13_7&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">13</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">7</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">2</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;14_2&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">14</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">2</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span>
</code></pre></div>对象中的<code>key</code>为<code>r + '_' + c</code>的拼接值，<code>value</code>为左上角单元格信息: r:行数，c:列数，rs：合并的行数，cs:合并的列数</li></ul> <h4 id="config-rowlen"><a href="#config-rowlen" class="header-anchor">#</a> config.rowlen</h4> <ul><li>类型：Object</li> <li>默认值：{}</li> <li>作用：每个单元格的行高</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;rowlen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
            <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
            <span class="token string">&quot;2&quot;</span><span class="token operator">:</span> <span class="token number">20</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h4 id="config-columnlen"><a href="#config-columnlen" class="header-anchor">#</a> config.columnlen</h4> <ul><li>类型：Object</li> <li>默认值：{}</li> <li>作用：每个单元格的列宽</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;columnlen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token number">97</span><span class="token punctuation">,</span>
            <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token number">115</span><span class="token punctuation">,</span>
            <span class="token string">&quot;2&quot;</span><span class="token operator">:</span> <span class="token number">128</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h4 id="config-rowhidden"><a href="#config-rowhidden" class="header-anchor">#</a> config.rowhidden</h4> <ul><li><p>类型：Object</p></li> <li><p>默认值：{}</p></li> <li><p>作用：隐藏行信息，格式为：<code>rowhidden[行数]: 0</code>,</p> <p><code>key</code>指定行数即可，<code>value</code>总是为<code>0</code></p></li> <li><p>示例：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;30&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
            <span class="token string">&quot;31&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h4 id="config-colhidden"><a href="#config-colhidden" class="header-anchor">#</a> config.colhidden</h4> <ul><li><p>类型：Object</p></li> <li><p>默认值：{}</p></li> <li><p>作用：隐藏列
格式为：<code>colhidden[列数]: 0</code>,</p> <div class="language- extra-class"><pre><code>  `key`指定列数即可，`value`总是为`0`
</code></pre></div></li> <li><p>示例：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;colhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;30&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
            <span class="token string">&quot;31&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h4 id="config-borderinfo"><a href="#config-borderinfo" class="header-anchor">#</a> config.borderInfo</h4> <ul><li><p>类型：Array</p></li> <li><p>默认值：{}</p></li> <li><p>作用：单元格的边框信息</p></li> <li><p>示例：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;borderInfo&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;cell&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;value&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;row_index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;col_index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;l&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;t&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;b&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;range&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;borderType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;border-all&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#0000ff&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
            <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">7</span><span class="token punctuation">,</span> <span class="token number">8</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
            <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">]</span>
        <span class="token punctuation">}</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;range&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;borderType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;border-inside&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#0000ff&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
            <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">7</span><span class="token punctuation">,</span> <span class="token number">8</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
            <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">8</span><span class="token punctuation">,</span> <span class="token number">9</span><span class="token punctuation">]</span>
        <span class="token punctuation">}</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div><p>范围类型分单个单元格和选区两种情况</p> <ol><li><p>选区 <code>rangeType: &quot;range&quot;</code></p> <ul><li>边框类型 <code>borderType：&quot;border-left&quot; | &quot;border-right&quot; | &quot;border-top&quot; | &quot;border-bottom&quot; | &quot;border-all&quot; | &quot;border-outside&quot; | &quot;border-inside&quot; | &quot;border-horizontal&quot; | &quot;border-vertical&quot; | &quot;border-none&quot;</code>，</li> <li>边框粗细 <code>style: 1 Thin | 2 Hair | 3 Dotted | 4 Dashed | 5 DashDot | 6 DashDotDot | 7 Double | 8 Medium | 9 MediumDashed | 10 MediumDashDot | 11 MediumDashDotDot | 12 SlantedDashDot | 13 Thick</code>，和aspose.cells的getLineStyle()的值对应的话，需要自己做个转换，参考 <a href="https://apireference.aspose.com/cells/net/aspose.cells/cellbordertype" target="_blank" rel="noopener noreferrer">aspose.cells<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li> <li>边框颜色 <code>color: 16进制颜色值</code></li> <li>选区范围 <code>range: 行列信息数组</code></li></ul></li> <li><p>单个单元格 <code>rangeType：&quot;cell&quot;</code></p> <ul><li>单元格的行数和列数索引 <code>value.row_index: 数字，value.col_index: 数字</code></li> <li>四个边框对象 <code>value.l:左边框，value.r:右边框，value.t:上边框，value.b:下边框</code></li> <li>边框粗细 <code>value.l.style: 1 Thin | 2 Hair | 3 Dotted | 4 Dashed | 5 DashDot | 6 DashDotDot | 7 Double | 8 Medium | 9 MediumDashed | 10 MediumDashDot | 11 MediumDashDotDot | 12 SlantedDashDot | 13 Thick</code></li> <li>边框颜色 <code>value.l.color: 16进制颜色值</code></li></ul></li></ol> <p>更多模板：</p> <div class="language- extra-class"><pre><code>  + ```js
  {
      &quot;rangeType&quot;: &quot;range&quot;,
      &quot;borderType&quot;: &quot;border-all&quot;,
      &quot;style&quot;: &quot;3&quot;,
      &quot;color&quot;: &quot;#0000ff&quot;,
      &quot;range&quot;: [{
          &quot;row&quot;: [7, 8],
          &quot;column&quot;: [2, 3]
      }]
  }
  ```
  表示设置范围为`{&quot;row&quot;: [7, 8],&quot;column&quot;: [2, 3]}`的选区，类型为所有边框，边框粗细为`Dotted`，颜色为`&quot;#0000ff&quot;`

  + ```js
      {
          &quot;rangeType&quot;: &quot;cell&quot;,
          &quot;value&quot;: {
              &quot;row_index&quot;: 3,
              &quot;col_index&quot;: 3,
              &quot;l&quot;: {
                  &quot;style&quot;: 10,
                  &quot;color&quot;: &quot;rgb(255, 0, 0)&quot;
              },
              &quot;r&quot;: {
                  &quot;style&quot;: 10,
                  &quot;color&quot;: &quot;rgb(255, 0, 0)&quot;
              },
              &quot;t&quot;: {
                  &quot;style&quot;: 10,
                  &quot;color&quot;: &quot;rgb(255, 0, 0)&quot;
              },
              &quot;b&quot;: {
                  &quot;style&quot;: 10,
                  &quot;color&quot;: &quot;rgb(255, 0, 0)&quot;
              }
          }
      }
      ```
      表示设置单元格`&quot;D4&quot;`，上边框/下边框/左边框/右边框都是边框粗细为`&quot;MediumDashDot&quot;`,颜色为`&quot;rgb(255, 0, 0)&quot;`
</code></pre></div></li></ul> <h4 id="config-authority"><a href="#config-authority" class="header-anchor">#</a> config.authority</h4> <ul><li>类型：Object</li> <li>默认值：{}</li> <li>作用：工作表保护，可以设置当前整个工作表不允许编辑或者部分区域不可编辑，如果要申请编辑权限需要输入密码，自定义配置用户可以操作的类型等。</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;authority&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token comment">//当前工作表的权限配置</span>
    selectLockedCells<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//选定锁定单元格</span>
    selectunLockedCells<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//选定解除锁定的单元格</span>
    formatCells<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//设置单元格格式</span>
    formatColumns<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//设置列格式</span>
    formatRows<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//设置行格式</span>
    insertColumns<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//插入列</span>
    insertRows<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//插入行</span>
    insertHyperlinks<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//插入超链接</span>
    deleteColumns<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//删除列</span>
    deleteRows<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//删除行</span>
    sort<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//排序</span>
    filter<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//使用自动筛选</span>
    usePivotTablereports<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//使用数据透视表和报表</span>
    editObjects<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//编辑对象</span>
    editScenarios<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//编辑方案    </span>
    sheet<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//如果为1或true，则该工作表受到保护；如果为0或false，则该工作表不受保护。</span>
    hintText<span class="token operator">:</span><span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//弹窗提示的文字</span>
    algorithmName<span class="token operator">:</span><span class="token string">&quot;None&quot;</span><span class="token punctuation">,</span><span class="token comment">//加密方案：MD2,MD4,MD5,RIPEMD-128,RIPEMD-160,SHA-1,SHA-256,SHA-384,SHA-512,WHIRLPOOL</span>
    saltValue<span class="token operator">:</span><span class="token keyword">null</span><span class="token punctuation">,</span> <span class="token comment">//密码解密的盐参数，为一个自己定的随机数值</span>
    
    allowRangeList<span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span> <span class="token comment">//区域保护</span>
        name<span class="token operator">:</span><span class="token string">&quot;area&quot;</span><span class="token punctuation">,</span> <span class="token comment">//名称</span>
        password<span class="token operator">:</span><span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span> <span class="token comment">//密码</span>
        hintText<span class="token operator">:</span><span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//提示文字</span>
        algorithmName<span class="token operator">:</span><span class="token string">&quot;None&quot;</span><span class="token punctuation">,</span><span class="token comment">//加密方案：MD2,MD4,MD5,RIPEMD-128,RIPEMD-160,SHA-1,SHA-256,SHA-384,SHA-512,WHIRLPOOL</span>
        saltValue<span class="token operator">:</span><span class="token keyword">null</span><span class="token punctuation">,</span> <span class="token comment">//密码解密的盐参数，为一个自己定的随机数值</span>
        sqref<span class="token operator">:</span><span class="token string">&quot;$C$1:$D$5&quot;</span> <span class="token comment">//区域范围</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span>
</code></pre></div></li></ul> <hr> <h3 id="scrollleft"><a href="#scrollleft" class="header-anchor">#</a> scrollLeft</h3> <ul><li>类型：Number</li> <li>默认值：0</li> <li>作用： 左右滚动条位置</li></ul> <hr> <h3 id="scrolltop"><a href="#scrolltop" class="header-anchor">#</a> scrollTop</h3> <ul><li>类型：Number</li> <li>默认值：0</li> <li>作用： 上下滚动条位置</li></ul> <hr> <h3 id="luckysheet-select-save"><a href="#luckysheet-select-save" class="header-anchor">#</a> luckysheet_select_save</h3> <ul><li>类型：Array</li> <li>默认值：[]</li> <li>作用： 选中的区域，支持多选，是一个包含多个选区对象的一维数组</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">1</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">0</span> <span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">4</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">3</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span> <span class="token punctuation">]</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="calcchain"><a href="#calcchain" class="header-anchor">#</a> calcChain</h3> <ul><li><p>类型：Array</p></li> <li><p>默认值：[]</p></li> <li><p>作用： 公式链是一个由用户指定顺序排列的公式信息数组，Luckysheet会根据此顺序来决定公式执行的顺序。</p> <p>注意，在初始化工作簿的时候，如果有单元格包含公式，请务必添加对应单元格位置的公式链，否则Luckysheet无法识别公式。</p></li> <li><p>示例：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token comment">//行数</span>
    <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token comment">//列数</span>
    <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//工作表id</span>
    <span class="token string">&quot;func&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token number">23.75</span><span class="token punctuation">,</span> <span class="token string">&quot;=AVERAGE(D3:D6)&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//公式信息，包含公式计算结果和公式字符串</span>
    <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;w&quot;</span><span class="token punctuation">,</span> <span class="token comment">//&quot;w&quot;：采用深度优先算法 &quot;b&quot;:普通计算</span>
    <span class="token string">&quot;parent&quot;</span><span class="token operator">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span>
    <span class="token string">&quot;chidren&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;times&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">7</span><span class="token punctuation">,</span>
    <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
    <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
    <span class="token string">&quot;func&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token number">30</span><span class="token punctuation">,</span> <span class="token string">&quot;=MAX(D3:D6)&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;w&quot;</span><span class="token punctuation">,</span>
    <span class="token string">&quot;parent&quot;</span><span class="token operator">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span>
    <span class="token string">&quot;chidren&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;times&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="ispivottable"><a href="#ispivottable" class="header-anchor">#</a> isPivotTable</h3> <ul><li>类型：Boolean</li> <li>默认值：false</li> <li>作用： 是否数据透视表</li></ul> <hr> <h3 id="pivottable"><a href="#pivottable" class="header-anchor">#</a> pivotTable</h3> <ul><li>类型：Object</li> <li>默认值：{}</li> <li>作用： 数据透视表设置</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
    <span class="token string">&quot;pivot_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;pivotDataSheetIndex&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token comment">//源数据所在的sheet页</span>
    <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
        <span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;subject&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;subject&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;student&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;student&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;values&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">4</span><span class="token punctuation">,</span>
        <span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;score&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;count:score&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;sumtype&quot;</span><span class="token operator">:</span> <span class="token string">&quot;COUNTA&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;nameindex&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;showType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;column&quot;</span><span class="token punctuation">,</span>
    <span class="token string">&quot;pivotDatas&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token comment">//数据透视表的源数据</span>
        <span class="token punctuation">[</span><span class="token string">&quot;count:score&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;science&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;mathematics&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;foreign language&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;English&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;total&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token punctuation">[</span><span class="token string">&quot;Alex&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token punctuation">[</span><span class="token string">&quot;Joy&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token punctuation">[</span><span class="token string">&quot;Tim&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token punctuation">[</span><span class="token string">&quot;total&quot;</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span>
    <span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;drawPivotTable&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
    <span class="token string">&quot;pivotTableBoundary&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">5</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div></li></ul> <hr> <h3 id="filter-select"><a href="#filter-select" class="header-anchor">#</a> filter_select</h3> <ul><li>类型：Object</li> <li>默认值：{}</li> <li>作用： 筛选范围。一个选区，一个sheet只有一个筛选范围，类似<code>luckysheet_select_save</code>。如果仅仅只是创建一个选区打开筛选功能，则配置这个范围即可，如果还需要进一步设置详细的筛选条件，则需要另外配置同级的 <a href="#filter">filter</a> 属性。</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
    
    <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">6</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">3</span> <span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div></li></ul> <hr> <h3 id="filter"><a href="#filter" class="header-anchor">#</a> filter</h3> <ul><li><p>类型：Object</p></li> <li><p>默认值：{}</p></li> <li><p>作用： 筛选的具体设置，跟<code>filter_select</code>筛选范围是互相搭配的。当你在第一个sheet页创建了一个筛选区域，通过<code>luckysheet.getLuckysheetfile()[0].filter</code>也可以看到第一个sheet的筛选配置信息。</p> <p>以下是一个完整的筛选配置案例</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>   
    <span class="token comment">//&quot;0&quot;表示第一列</span>
    <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;caljs&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">// 按条件筛选</span>
            <span class="token string">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;cellnull&quot;</span><span class="token punctuation">,</span> <span class="token comment">// 筛选类型</span>
            <span class="token string">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Is empty&quot;</span><span class="token punctuation">,</span> <span class="token comment">// 类型说明</span>
            <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span> <span class="token comment">// 筛选大类</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token string">&quot;3&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token string">&quot;4&quot;</span><span class="token operator">:</span> <span class="token number">0</span> <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">// 隐藏行信息</span>
        <span class="token string">&quot;optionstate&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token comment">// 是否开启配置</span>
        <span class="token string">&quot;cindex&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">// 当前范围列顺序，这里表示第一列</span>
        <span class="token string">&quot;str&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token comment">// 范围，起始行</span>
        <span class="token string">&quot;edr&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token comment">// 范围，结束行</span>
        <span class="token string">&quot;stc&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">// 范围，起始列</span>
        <span class="token string">&quot;edc&quot;</span><span class="token operator">:</span> <span class="token number">3</span> <span class="token comment">// 范围，结束列</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token comment">//&quot;1&quot;表示第二列</span>
    <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;caljs&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;optionstate&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cindex&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token comment">// 当前范围列顺序，这里表示第二列</span>
        <span class="token string">&quot;str&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token string">&quot;edr&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span>
        <span class="token string">&quot;stc&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token string">&quot;edc&quot;</span><span class="token operator">:</span> <span class="token number">3</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div><ol><li><code>filter[key]</code>的<code>key</code>值，表示是列索引，从0开始，具体设置项中的<code>cindex</code>是从1开始，和这里的<code>key</code>是同一个意思。</li> <li><code>caljs</code>用来设置按条件筛选的类型和对应的值，设置生效后，会计算隐藏行信息存储在<code>rowhidden</code>中。以下是全部的可设置的类型，其中<code>value1</code>和<code>value2</code>就是用户自己填的文本信息：
<ul><li><code>caljs:{value: null, text: &quot;无&quot;, type: &quot;0&quot;}</code></li> <li><code>caljs:{value: &quot;cellnull&quot;, text: &quot;单元格为空&quot;, type: &quot;0&quot;}</code></li> <li><code>caljs:{value: &quot;cellnonull&quot;, text: &quot;单元格有数据&quot;, type: &quot;0&quot;}</code></li> <li><code>caljs:{value: &quot;textinclude&quot;, text: &quot;文本包含&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;textnotinclude&quot;, text: &quot;文本不包含&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;textstart&quot;, text: &quot;文本开头为&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;textend&quot;, text: &quot;文本结尾为&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;textequal&quot;, text: &quot;文本等于&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;dateequal&quot;, text: &quot;日期等于&quot;, type: &quot;1&quot;, value1: &quot;2020-10-16&quot;}</code></li> <li><code>caljs:{value: &quot;datelessthan&quot;, text: &quot;日期早于&quot;, type: &quot;1&quot;, value1: &quot;2020-10-16&quot;}</code></li> <li><code>caljs:{value: &quot;datemorethan&quot;, text: &quot;日期晚于&quot;, type: &quot;1&quot;, value1: &quot;2020-10-16&quot;}</code></li> <li><code>caljs:{value: &quot;morethan&quot;, text: &quot;大于&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;moreequalthan&quot;, text: &quot;大于等于&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;lessthan&quot;, text: &quot;小于&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;lessequalthan&quot;, text: &quot;小于等于&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;equal&quot;, text: &quot;等于&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;noequal&quot;, text: &quot;不等于&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;include&quot;, text: &quot;介于&quot;, type: &quot;2&quot;, value1: &quot;15&quot;, value2: &quot;25&quot;}</code></li> <li><code>caljs:{value: &quot;noinclude&quot;, text: &quot;不在其中&quot;, type: &quot;2&quot;, value1: &quot;15&quot;, value2: &quot;25&quot;}</code></li></ul></li> <li><code>rowhidden</code>是存储的隐藏行信息，但是如果没有设置<code>caljs</code>按条件筛选，则表明是设置了按颜色筛选（如果行之间有颜色区分的话）和按值进行筛选。所以可以看出，<code>caljs</code>的优先级大于<code>rowhidden</code>。</li> <li><code>optionstate</code>表示是否开启配置，这是一个内部标识，直接设置<code>true</code>即可。</li> <li><code>cindex</code>表示当前设置的列顺序，从1开始计数，和<code>filter[key]</code>的<code>key</code>值形成对应，结果是<code>key</code>+1。</li> <li><code>str</code>是起始行，<code>edr</code>是结束行，<code>stc</code>是起始列，<code>edc</code>是结束列，四个数字代表整个筛选范围，与<code>filter_select</code>的内容保持一致即可。</li></ol></li></ul> <hr> <h3 id="luckysheet-alternateformat-save"><a href="#luckysheet-alternateformat-save" class="header-anchor">#</a> luckysheet_alternateformat_save</h3> <ul><li>类型：Array</li> <li>默认值：[]</li> <li>作用： 交替颜色配置</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
    <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//单元格范围</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">5</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//页眉颜色</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#5ed593&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//第一种颜色</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//第二种颜色</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#e5fbee&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//页脚颜色</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#a5efcc&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;hasRowHeader&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span> <span class="token comment">//含有页眉</span>
    <span class="token string">&quot;hasRowFooter&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span> <span class="token comment">//含有页脚</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
    <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">8</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#5599fc&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ecf2fe&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#afcbfa&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;hasRowHeader&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
    <span class="token string">&quot;hasRowFooter&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="luckysheet-alternateformat-save-modelcustom"><a href="#luckysheet-alternateformat-save-modelcustom" class="header-anchor">#</a> luckysheet_alternateformat_save_modelCustom</h3> <ul><li>类型：Array</li> <li>默认值：[]</li> <li>作用：自定义交替颜色，包含多个自定义交替颜色的配置</li> <li>示例：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
    <span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//页眉颜色</span>
        <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#6aa84f&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//第一种颜色</span>
        <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//第二种颜色</span>
        <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#e5fbee&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//页脚颜色</span>
        <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#a5efcc&quot;</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="luckysheet-conditionformat-save"><a href="#luckysheet-conditionformat-save" class="header-anchor">#</a> luckysheet_conditionformat_save</h3> <ul><li><p>类型：Array</p></li> <li><p>默认值：[]</p></li> <li><p>作用： 条件格式配置信息，包含多个条件格式配置对象的一维数组，</p> <p>type: &quot;default&quot;: 突出显示单元格规则和项目选区规则，</p> <p>&quot;dataBar&quot;:数据条，</p> <p>&quot;icons&quot;:图标集，</p> <p>&quot;colorGradation&quot;: 色阶</p> <p>API中对此设置也有介绍<a href="/LuckysheetDocs/zh/guide/api.html">API setRangeConditionalFormat</a></p></li> <li><p>示例：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;default&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token comment">//应用的范围</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">7</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//type 为 default 时 应设置文本颜色和单元格颜色</span>
            <span class="token string">&quot;textColor&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cellColor&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ff0000&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;conditionName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;betweenness&quot;</span><span class="token punctuation">,</span> <span class="token comment">//类型</span>
        <span class="token string">&quot;conditionRange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token comment">//条件值所在单元格</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">4</span><span class="token punctuation">,</span> <span class="token number">4</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token number">6</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;conditionValue&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">4</span>
        <span class="token punctuation">]</span> <span class="token comment">//自定义传入的条件值</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;dataBar&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">15</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">11</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token string">&quot;#6aa84f&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;#ffffff&quot;</span>
        <span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;icons&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">19</span><span class="token punctuation">,</span> <span class="token number">23</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;len&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;leftMin&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;colorGradation&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">15</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token number">6</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token string">&quot;rgb(99, 190, 123)&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rgb(255, 235, 132)&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rgb(248, 105, 107)&quot;</span>
        <span class="token punctuation">]</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="frozen"><a href="#frozen" class="header-anchor">#</a> frozen</h3> <ul><li><p>类型：Array</p></li> <li><p>默认值：[]</p></li> <li><p>作用： 冻结行列设置，分为6种类型</p> <ol><li>&quot;row&quot;: 冻结首行</li> <li>&quot;column&quot;: 冻结首列</li> <li>&quot;both&quot;: 冻结行列</li> <li>&quot;rangeRow&quot;: 冻结行到选区</li> <li>&quot;rangeColumn&quot;: 冻结列到选区</li> <li>&quot;rangeBoth&quot;: 冻结行列到选区</li> <li>&quot;cancel&quot;: 取消冻结</li></ol> <p>当设置冻结到选区的时候，需要设置开启冻结的单元格位置，格式为<code>{ row_focus:0, column_focus:0 }</code>，意为当前激活的单元格的行数和列数。</p> <p>sheet新的配置属性，存储更语义化的配置，用于初始化和传给后端。</p> <p>注意一点，luckysheetfile中还有一个配置freezen，其中的freezenhorizontaldata仍然用作本地数据，但是不发给后台存储，只做本地调试。</p></li> <li><p>示例：</p> <ul><li>冻结首行</li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    type<span class="token operator">:</span> 'row'
<span class="token punctuation">}</span>
</code></pre></div><ul><li>冻结行到<code>'A1'</code>选区</li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
   type<span class="token operator">:</span> 'rangeRow'<span class="token punctuation">,</span>
   range<span class="token operator">:</span> <span class="token punctuation">{</span>row_focus<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> column_focus<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>冻结行列到<code>'B2'</code>选区</li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
   type<span class="token operator">:</span> 'rangeBoth'<span class="token punctuation">,</span>
   range<span class="token operator">:</span> <span class="token punctuation">{</span>row_focus<span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> column_focus<span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div></li></ul> <hr> <h3 id="chart"><a href="#chart" class="header-anchor">#</a> chart</h3> <ul><li>类型：Array</li> <li>默认值：[]</li> <li>作用： 图表配置，参照chartMix的配置格式，允许只设置想要的图表属性，一个完整的配置案例如下。</li> <li>示例：<details class="custom-block details"><summary>DETAILS</summary> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    <span class="token property">&quot;chart_id&quot;</span><span class="token operator">:</span> <span class="token string">&quot;chart_p145W6i73otw_1596209943446&quot;</span><span class="token punctuation">,</span>
    <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">400</span><span class="token punctuation">,</span>
    <span class="token property">&quot;height&quot;</span><span class="token operator">:</span> <span class="token number">250</span><span class="token punctuation">,</span>
    <span class="token property">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
    <span class="token property">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">120</span><span class="token punctuation">,</span>
    <span class="token property">&quot;sheetIndex&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet_6az6nei65t1i_1596209937084&quot;</span><span class="token punctuation">,</span>
    <span class="token property">&quot;needRangeShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
    <span class="token property">&quot;chartOptions&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token property">&quot;chart_id&quot;</span><span class="token operator">:</span> <span class="token string">&quot;chart_p145W6i73otw_1596209943446&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;chartAllType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;echarts|line|default&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;rangeArray&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token punctuation">{</span> <span class="token property">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">4</span> <span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token property">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">7</span> <span class="token punctuation">]</span> <span class="token punctuation">}</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;rangeColCheck&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token property">&quot;exits&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token property">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">0</span> <span class="token punctuation">]</span> <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;rangeRowCheck&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token property">&quot;exits&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token property">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">0</span> <span class="token punctuation">]</span> <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;rangeConfigCheck&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
        <span class="token property">&quot;defaultOption&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;默认标题&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;left-top&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;offsetX&quot;</span><span class="token operator">:</span> <span class="token number">40</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;offsetY&quot;</span><span class="token operator">:</span> <span class="token number">50</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;subtitle&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusGap&quot;</span><span class="token operator">:</span> <span class="token number">40</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;transparent&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sans-serif&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;grid&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;normal&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;right&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;bottom&quot;</span><span class="token operator">:</span> <span class="token number">10</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;legend&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                <span class="token property">&quot;selectMode&quot;</span><span class="token operator">:</span> <span class="token string">&quot;multiple&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;selected&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;衣服&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;isShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;食材&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;isShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;图书&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;isShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;left-top&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;offsetX&quot;</span><span class="token operator">:</span> <span class="token number">40</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;offsetY&quot;</span><span class="token operator">:</span> <span class="token number">50</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;direction&quot;</span><span class="token operator">:</span> <span class="token string">&quot;horizontal&quot;</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusSize&quot;</span><span class="token operator">:</span> <span class="token number">25</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;height&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusSize&quot;</span><span class="token operator">:</span> <span class="token number">14</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusGap&quot;</span><span class="token operator">:</span> <span class="token number">10</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;itemGap&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
                    <span class="token string">&quot;Mon&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Tues&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Wed&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Thur&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Fri&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Sat&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Sun&quot;</span>
                <span class="token punctuation">]</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;tooltip&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;backgroundColor&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgba(50,50,50,0.7)&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;triggerOn&quot;</span><span class="token operator">:</span> <span class="token string">&quot;mousemove&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;triggerType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;item&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;axisPointer&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;line&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;style&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#555&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token string">&quot;normal&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;衣服&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;食材&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;图书&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;axis&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;axisType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;xAxisDown&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;xAxisUp&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;showTitle&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;nameGap&quot;</span><span class="token operator">:</span> <span class="token number">15</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;fzPosition&quot;</span><span class="token operator">:</span> <span class="token string">&quot;end&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;显示X轴&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;inverse&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tick&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;outside&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;length&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLabel&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;optimize&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;min&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;max&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netArea&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorOne&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorTwo&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;axisLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;onZero&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;xAxisDown&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;showTitle&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;nameGap&quot;</span><span class="token operator">:</span> <span class="token number">15</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;fzPosition&quot;</span><span class="token operator">:</span> <span class="token string">&quot;end&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;显示X轴&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;inverse&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tick&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;outside&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;length&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLabel&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;optimize&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;min&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;max&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netArea&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorOne&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorTwo&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
                        <span class="token string">&quot;BUS&quot;</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;UBER&quot;</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;TAXI&quot;</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;SUBWAY&quot;</span>
                    <span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;category&quot;</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;yAxisLeft&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;showTitle&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;nameGap&quot;</span><span class="token operator">:</span> <span class="token number">15</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;fzPosition&quot;</span><span class="token operator">:</span> <span class="token string">&quot;end&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;显示Y轴&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;inverse&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tick&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;outside&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;length&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLabel&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;formatter&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;split&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;min&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;max&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netArea&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorOne&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorTwo&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;value&quot;</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;yAxisRight&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;showTitle&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;nameGap&quot;</span><span class="token operator">:</span> <span class="token number">15</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;fzPosition&quot;</span><span class="token operator">:</span> <span class="token string">&quot;end&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;显示Y轴&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;inverse&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tick&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;outside&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;length&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLabel&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;formatter&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;split&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;min&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;max&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netArea&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorOne&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorTwo&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token property">&quot;isShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span>
<span class="token punctuation">}</span>
</code></pre></div><p>:::</p></details></li></ul> <hr> <h3 id="zoomratio"><a href="#zoomratio" class="header-anchor">#</a> zoomRatio</h3> <ul><li>类型：Number</li> <li>默认值：1</li> <li>作用： 此sheet页的缩放比例，为0~1之间的二位小数数字。比如<code>0.1</code>、<code>0.56</code></li></ul> <hr> <h3 id="image"><a href="#image" class="header-anchor">#</a> image</h3> <ul><li>类型：Array</li> <li>默认值：[]</li> <li>作用： 插入表格中图片信息，包含图片地址、宽高、位置、裁剪等信息</li> <li>示例：
以下为一个<code>imageItem</code>案例，通常一个工作表中可能存在多个图片，所以<code>image</code>的格式为数组<code>[imageItem,imageItem,...]</code><div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    type<span class="token operator">:</span> '<span class="token number">3</span>'<span class="token punctuation">,</span>  <span class="token comment">//1移动并调整单元格大小 2移动并且不调整单元格的大小 3不要移动单元格并调整其大小</span>
    src<span class="token operator">:</span> ''<span class="token punctuation">,</span>  <span class="token comment">//图片url</span>
    originWidth<span class="token operator">:</span> <span class="token number">1484</span><span class="token punctuation">,</span>  <span class="token comment">//图片原始宽度</span>
    originHeight<span class="token operator">:</span> <span class="token number">834</span><span class="token punctuation">,</span>  <span class="token comment">//图片原始高度</span>
    default<span class="token operator">:</span> <span class="token punctuation">{</span>
        width<span class="token operator">:</span> <span class="token number">293</span><span class="token punctuation">,</span>  <span class="token comment">//图片 宽度</span>
        height<span class="token operator">:</span> <span class="token number">196</span><span class="token punctuation">,</span>  <span class="token comment">//图片 高度</span>
        left<span class="token operator">:</span> <span class="token number">409</span><span class="token punctuation">,</span>  <span class="token comment">//图片离表格左边的 位置</span>
        top<span class="token operator">:</span> <span class="token number">248</span><span class="token punctuation">,</span>  <span class="token comment">//图片离表格顶部的 位置</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    crop<span class="token operator">:</span> <span class="token punctuation">{</span>
        width<span class="token operator">:</span> <span class="token number">293</span><span class="token punctuation">,</span>  <span class="token comment">//图片裁剪后 宽度</span>
        height<span class="token operator">:</span> <span class="token number">196</span><span class="token punctuation">,</span>  <span class="token comment">//图片裁剪后 高度</span>
        offsetLeft<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>  <span class="token comment">//图片裁剪后离未裁剪时 左边的位移</span>
        offsetTop<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>  <span class="token comment">//图片裁剪后离未裁剪时 顶部的位移</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    isFixedPos<span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>  <span class="token comment">//固定位置</span>
    fixedLeft<span class="token operator">:</span> <span class="token number">507</span><span class="token punctuation">,</span>  <span class="token comment">//固定位置 左位移</span>
    fixedTop<span class="token operator">:</span> <span class="token number">141</span><span class="token punctuation">,</span>  <span class="token comment">//固定位置 右位移</span>
    border<span class="token operator">:</span> <span class="token punctuation">{</span>
        width<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>  <span class="token comment">//边框宽度</span>
        radius<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>  <span class="token comment">//边框半径</span>
        style<span class="token operator">:</span> 'solid'<span class="token punctuation">,</span>  <span class="token comment">//边框类型</span>
        color<span class="token operator">:</span> '#<span class="token number">000</span>'<span class="token punctuation">,</span>  <span class="token comment">//边框颜色</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div></li></ul> <hr> <h3 id="showgridlines"><a href="#showgridlines" class="header-anchor">#</a> showGridLines</h3> <ul><li>类型：Number</li> <li>默认值：1</li> <li>作用：是否显示网格线，<code>1</code>表示显示，<code>0</code>表示隐藏</li></ul> <hr> <h3 id="dataverification"><a href="#dataverification" class="header-anchor">#</a> dataVerification</h3> <ul><li>类型：Object</li> <li>默认值：{}</li> <li>作用：数据验证的配置信息。以下列出了所有需要设置的详细字段：
<ul><li><p>{String} [type]: 类型；值可为</p> <ul><li><code>&quot;dropdown&quot;</code>(下拉列表)</li> <li><code>&quot;checkbox&quot;</code>(复选框)</li> <li><code>&quot;number&quot;</code>(数字)</li> <li><code>&quot;number_integer&quot;</code>(数字-整数)</li> <li><code>&quot;number_decimal&quot;</code>(数字-小数)</li> <li><code>&quot;text_content&quot;</code>(文本-内容)</li> <li><code>&quot;text_length&quot;</code>(文本-长度)</li> <li><code>&quot;date&quot;</code>(日期)</li> <li><code>&quot;validity&quot;</code>(有效性)；</li></ul></li> <li><p>{String | Null} [type2]: 条件类型；</p> <ul><li>类型<code>type</code>值为<code>&quot;dropdown&quot;/&quot;checkbox&quot;</code>时，<code>type2</code>值可为
<ul><li><code>null</code>；</li></ul></li> <li>类型<code>type</code>值为<code>&quot;number&quot;/&quot;number_integer&quot;/&quot;number_decimal&quot;/&quot;text_length&quot;</code>时，<code>type2</code>值可为
<ul><li><code>&quot;bw&quot;</code>(介于)</li> <li><code>&quot;nb&quot;</code>(不介于)</li> <li><code>&quot;eq&quot;</code>(等于)</li> <li><code>&quot;ne&quot;</code>(不等于)</li> <li><code>&quot;gt&quot;</code>(大于)</li> <li><code>&quot;lt&quot;</code>(小于)</li> <li><code>&quot;gte&quot;</code>(大于等于)</li> <li><code>&quot;lte&quot;</code>(小于等于)</li></ul></li> <li>类型<code>type</code>值为<code>&quot;text_content&quot;</code>时，<code>type2</code>值可为
<ul><li><code>&quot;include&quot;</code>(包括)</li> <li><code>&quot;exclude&quot;</code>(不包括)</li> <li><code>&quot;equal&quot;</code>(等于)</li></ul></li> <li>类型<code>type</code>值为<code>&quot;date&quot;</code>时，<code>type2</code>值可为
<ul><li><code>&quot;bw&quot;</code>(介于)</li> <li><code>&quot;nb&quot;</code>(不介于)</li> <li><code>&quot;eq&quot;</code>(等于)</li> <li><code>&quot;ne&quot;</code>(不等于)</li> <li><code>&quot;bf&quot;</code>(早于)</li> <li><code>&quot;nbf&quot;</code>(不早于)</li> <li><code>&quot;af&quot;</code>(晚于)</li> <li><code>&quot;naf&quot;</code>(不晚于)</li></ul></li> <li>类型<code>type</code>值为<code>&quot;validity&quot;</code>时，<code>type2</code>值可为
<ul><li><code>&quot;card&quot;</code>(身份证号码)</li> <li><code>&quot;phone&quot;</code>(手机号)；</li></ul></li></ul></li> <li><p>{String | Number} [value1]: 条件值1；</p> <ul><li>类型<code>type</code>值为<code>&quot;dropdown&quot;</code>时，<code>value1</code>值可为选区或以英文逗号隔开的字符串，如<code>&quot;1,2,3&quot;</code>或者<code>&quot;A1:B2&quot;</code>；</li> <li>类型<code>type</code>值为<code>&quot;validity&quot;</code>时，<code>value1</code>值可为空；</li> <li>其他类型时<code>value1</code>值为数值或字符串；</li></ul></li> <li><p>{String | Number} [value2]: 条件值2；</p> <ul><li>类型<code>type</code>值为<code>&quot;checkbox&quot;</code>或者条件类型<code>type2</code>值为<code>&quot;bw&quot;</code>、<code>&quot;nb&quot;</code>时有<code>value2</code>值，条件值为数值或日期时，条件值2要大于等于条件值1；其它情况可为空；</li></ul></li> <li><p>{Boolean} [remote]: 自动远程获取选项；默认为<code>false</code>；</p></li> <li><p>{Boolean} [prohibitInput]: 输入数据无效时禁止输入；默认为<code>false</code>；</p></li> <li><p>{Boolean} [hintShow]: 选中单元格时显示提示语；默认为<code>false</code>；</p></li> <li><p>{String} [hintText]: 提示语文本；<code>hintShow</code>为<code>true</code>时需配置；</p></li> <li><p>{Boolean} [checked]: 是否勾选中复选框；<code>type</code>为<code>checkbox</code>时需配置；</p> <p>一个完整的配置案例请参考源码DEMO示例 <a href="https://github.com/mengshukeji/Luckysheet/blob/master/src/demoData/sheetDataVerification.js" target="_blank" rel="noopener noreferrer">/src/demoData/sheetDataVerification.js<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></p></li></ul></li></ul> <hr> <h2 id="调试信息"><a href="#调试信息" class="header-anchor">#</a> 调试信息</h2> <p>初始化所需要的参数，会从简洁的角度出发来考虑设计，但是本地存储的参数则不同。</p> <p>Luckysheet在初始化完成之后进行的一系列操作，会将更多本地参数存储在luckysheetfile中，作为本地使用的参数，实现一些类似Store数据中心的作用。比如，freezen的参数格式也会变化。</p> <p>此时的luckysheetfile包含很多非初始化使用的本地参数，可用于调试代码、本地状态分析。如下展示了更丰富luckysheetfile信息，可通过方法 <code>luckysheet.getluckysheetfile()</code>获得：</p> <details class="custom-block details"><summary>DETAILS</summary> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Cell&quot;</span><span class="token punctuation">,</span> <span class="token comment">//工作表名称</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//工作表颜色</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//工作表索引</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//激活状态</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//工作表的下标</span>
        <span class="token property">&quot;hide&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span><span class="token comment">//是否隐藏</span>
        <span class="token property">&quot;row&quot;</span><span class="token operator">:</span> <span class="token number">36</span><span class="token punctuation">,</span> <span class="token comment">//行数</span>
        <span class="token property">&quot;column&quot;</span><span class="token operator">:</span> <span class="token number">18</span><span class="token punctuation">,</span> <span class="token comment">//列数</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//初始化使用的单元格数据</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;merge&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//合并单元格</span>
            <span class="token property">&quot;rowlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//表格行高</span>
            <span class="token property">&quot;columnlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//表格列宽</span>
            <span class="token property">&quot;rowhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//隐藏行</span>
            <span class="token property">&quot;colhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//隐藏列</span>
            <span class="token property">&quot;borderInfo&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//边框</span>
            <span class="token property">&quot;authority&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//工作表保护</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;scrollLeft&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//左右滚动条位置</span>
        <span class="token property">&quot;scrollTop&quot;</span><span class="token operator">:</span> <span class="token number">315</span><span class="token punctuation">,</span> <span class="token comment">//上下滚动条位置</span>
        <span class="token property">&quot;luckysheet_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//选中的区域</span>
        <span class="token property">&quot;calcChain&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span><span class="token comment">//公式链</span>
        <span class="token property">&quot;isPivotTable&quot;</span><span class="token operator">:</span><span class="token boolean">false</span><span class="token punctuation">,</span><span class="token comment">//是否数据透视表</span>
        <span class="token property">&quot;pivotTable&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//数据透视表设置</span>
        <span class="token property">&quot;filter_select&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//筛选范围</span>
        <span class="token property">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span><span class="token comment">//筛选配置</span>
        <span class="token property">&quot;luckysheet_alternateformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//交替颜色</span>
        <span class="token property">&quot;luckysheet_alternateformat_save_modelCustom&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//自定义交替颜色	</span>
        <span class="token property">&quot;luckysheet_conditionformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//条件格式</span>
        <span class="token property">&quot;frozen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//冻结行列配置</span>
        <span class="token property">&quot;freezen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//冻结行列的渲染数据存储</span>
        <span class="token property">&quot;chart&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//图表配置</span>
        <span class="token property">&quot;zoomRatio&quot;</span><span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">// 缩放比例</span>
        <span class="token property">&quot;image&quot;</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//图片</span>
        <span class="token property">&quot;showGridLines&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//是否显示网格线</span>
        <span class="token property">&quot;dataVerification&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span> <span class="token comment">//数据验证配置</span>
        

        <span class="token property">&quot;visibledatarow&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//所有行的位置</span>
        <span class="token property">&quot;visibledatacolumn&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//所有列的位置</span>
        <span class="token property">&quot;ch_width&quot;</span><span class="token operator">:</span> <span class="token number">2322</span><span class="token punctuation">,</span> <span class="token comment">//工作表区域的宽度</span>
        <span class="token property">&quot;rh_height&quot;</span><span class="token operator">:</span> <span class="token number">949</span><span class="token punctuation">,</span> <span class="token comment">//工作表区域的高度</span>
        <span class="token property">&quot;load&quot;</span><span class="token operator">:</span> <span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span> <span class="token comment">//已加载过此sheet的标识</span>
        <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//更新和存储使用的单元格数据</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet2&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet3&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div></details> <h3 id="visibledatarow"><a href="#visibledatarow" class="header-anchor">#</a> visibledatarow</h3> <ul><li>类型：Number</li> <li>默认值：[]</li> <li>作用： 所有行的位置信息，递增的行位置数据，初始化无需设置</li></ul> <hr> <h3 id="visibledatacolumn"><a href="#visibledatacolumn" class="header-anchor">#</a> visibledatacolumn</h3> <ul><li>类型：Number</li> <li>默认值：[]</li> <li>作用： 所有列的位置信息，递增的列位置数据，初始化无需设置</li></ul> <hr> <h3 id="ch-width"><a href="#ch-width" class="header-anchor">#</a> ch_width</h3> <ul><li>类型：Number</li> <li>默认值：2322</li> <li>作用： 整个工作表区域的宽度(包含边界的灰色区域)，初始化无需设置</li></ul> <hr> <h3 id="rh-height"><a href="#rh-height" class="header-anchor">#</a> rh_height</h3> <ul><li>类型：Number</li> <li>默认值：2322</li> <li>作用： 整个工作表区域的高度(包含边界的灰色区域)，初始化无需设置</li></ul> <hr> <h3 id="load"><a href="#load" class="header-anchor">#</a> load</h3> <ul><li>类型：Number</li> <li>默认值：0</li> <li>作用： 当前sheet是否加载过，内部标识，初始化无需设置</li></ul> <hr> <h3 id="data"><a href="#data" class="header-anchor">#</a> data</h3> <ul><li>类型：Array</li> <li>默认值：[]</li> <li>作用： 初始化时从celldata转换而来，后续操作表格的数据更新，会更新到这个data字段中，初始化无需设置</li> <li>示例：
以下是一个二行二列的数据<div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">[</span>
    <span class="token punctuation">[</span><span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token punctuation">[</span><span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value3&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value3&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value4&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value4&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span>
<span class="token punctuation">]</span>

</code></pre></div></li></ul> <hr></div> <footer class="page-edit"><div class="edit-link"><a href="https://github.com/mengshukeji/Luckysheet/edit/master/docs/zh/guide/sheet.md" target="_blank" rel="noopener noreferrer">在 GitHub 上编辑此页</a> <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></div> <div class="last-updated"><span class="prefix">上次更新:</span> <span class="time">1/19/2021, 1:33:53 AM</span></div></footer> <div class="page-nav"><p class="inner"><span class="prev">
      ←
      <a href="/LuckysheetDocs/zh/guide/config.html" class="prev">
        整体配置
      </a></span> <span class="next"><a href="/LuckysheetDocs/zh/guide/cell.html">
        单元格
      </a>
      →
    </span></p></div> </main></div><div class="global-ui"></div></div>
    <script src="/LuckysheetDocs/assets/js/app.02d9598d.js" defer></script><script src="/LuckysheetDocs/assets/js/2.daa13025.js" defer></script><script src="/LuckysheetDocs/assets/js/33.eded6080.js" defer></script>
  </body>
</html>
